<?php

namespace app\admin\controller;

use app\admin\model\AdminLog;
use app\admin\model\Deliver;
use app\admin\model\develop\Acuisitionscheme;
use app\admin\model\Order;
use app\admin\model\statistics\Acquisitionschemedetail;
use app\admin\model\statistics\Materialplan;
use app\common\controller\Backend;
use think\Config;
use think\Db;
use think\Hook;
use think\Session;
use think\Validate;

/**
 * 后台首页
 * @internal
 */
class Index extends Backend
{

    protected $noNeedLogin = ['login','test','upOrderSchedule','deleteDuplicateMaterialPlan'];
    protected $noNeedRight = ['index', 'logout'];
    protected $layout = '';

    public function _initialize()
    {
        parent::_initialize();
        //移除HTML标签
        $this->request->filter('trim,strip_tags,htmlspecialchars');
    }

    /**
     * 后台首页
     */
    public function index()
    {
        $cookieArr = ['adminskin' => "/^skin\-([a-z\-]+)\$/i", 'multiplenav' => "/^(0|1)\$/", 'multipletab' => "/^(0|1)\$/"];
        foreach ($cookieArr as $key => $regex) {
            $cookieValue = $this->request->cookie($key);
            if (!is_null($cookieValue) && preg_match($regex, $cookieValue)) {
                config('fastadmin.' . $key, $cookieValue);
            }
        }
        //左侧菜单
        list($menulist, $navlist, $fixedmenu, $referermenu) = $this->auth->getSidebar([
            'dashboard' => 'hot',
            'addon'     => ['new', 'red', 'badge'],
            'auth/rule' => __('Menu'),
            'general'   => ['new', 'purple'],
        ], $this->view->site['fixedpage']);
        $action = $this->request->request('action');
        if ($this->request->isPost()) {
            if ($action == 'refreshmenu') {
                $this->success('', null, ['menulist' => $menulist, 'navlist' => $navlist]);
            }
        }
        $this->assignconfig('cookie', ['prefix' => config('cookie.prefix')]);
        $this->view->assign('menulist', $menulist);
        $this->view->assign('navlist', $navlist);
        $this->view->assign('fixedmenu', $fixedmenu);
        $this->view->assign('referermenu', $referermenu);
        $this->view->assign('title', __('Home'));
        return $this->view->fetch();
    }

    /**
     * 管理员登录
     */
    public function login()
    {
        $url = $this->request->get('url', 'index/index');
        if ($this->auth->isLogin()) {
            $this->success(__("You've logged in, do not login again"), $url);
        }
        if ($this->request->isPost()) {
            $username = $this->request->post('username');
            $password = $this->request->post('password');
            $keeplogin = $this->request->post('keeplogin');
            $token = $this->request->post('__token__');
            $rule = [
                'username'  => 'require|length:3,30',
                'password'  => 'require|length:3,30',
                '__token__' => 'require|token',
            ];
            $data = [
                'username'  => $username,
                'password'  => $password,
                '__token__' => $token,
            ];
            if (Config::get('fastadmin.login_captcha')) {
                $rule['captcha'] = 'require|captcha';
                $data['captcha'] = $this->request->post('captcha');
            }
            $validate = new Validate($rule, [], ['username' => __('Username'), 'password' => __('Password'), 'captcha' => __('Captcha')]);
            $result = $validate->check($data);
            if (!$result) {
                $this->error($validate->getError(), $url, ['token' => $this->request->token()]);
            }
            AdminLog::setTitle(__('Login'));
            $result = $this->auth->login($username, $password, $keeplogin ? 86400 : 0);
            if ($result === true) {
                Hook::listen("admin_login_after", $this->request);
                $this->success(__('Login successful'), $url, ['url' => $url, 'id' => $this->auth->id, 'username' => $username, 'avatar' => $this->auth->avatar]);
            } else {
                $msg = $this->auth->getError();
                $msg = $msg ? $msg : __('Username or password is incorrect');
                $this->error($msg, $url, ['token' => $this->request->token()]);
            }
        }

        // 根据客户端的cookie,判断是否可以自动登录
        if ($this->auth->autologin()) {
            Session::delete("referer");
            $this->redirect($url);
        }
        $background = Config::get('fastadmin.login_background');
        $background = $background ? (stripos($background, 'http') === 0 ? $background : config('site.cdnurl') . $background) : '';
        $this->view->assign('background', $background);
        $this->view->assign('title', __('Login'));
        Hook::listen("admin_login_init", $this->request);
        return $this->view->fetch();
    }

    /**
     * 退出登录
     */
    public function logout()
    {
        if ($this->request->isPost()) {
            $this->auth->logout();
            Hook::listen("admin_logout_after", $this->request);
            $this->success(__('Logout successful'), 'index/login');
        }
        $html = "<form id='logout_submit' name='logout_submit' action='' method='post'>" . token() . "<input type='submit' value='ok' style='display:none;'></form>";
        $html .= "<script>document.forms['logout_submit'].submit();</script>";

        return $html;
    }

    public function test(){
        $order_id = $this->request->get('id');
        p(up_order_schedule($order_id));
    }

    //重新计算订单进度
    public function upOrderSchedule(){
        $orderModel =new Order();
        $ids = $orderModel->field('id')->select();
        foreach ($ids as $v){
            up_order_schedule($v->id);
        }

    }

    //去除重复的物料方案
    public function deleteDuplicateMaterialPlan(){
//        set_time_limit(0);
        $flag = true;
        Db::startTrans();

        //获取有重复记录的物料方案
        $sql = "SELECT a.id,a.trademark_printing,a.colour_id,c.`name` AS cname,COUNT(*) FROM fa_material_plan a
JOIN fa_colour c ON a.colour_id = c.id
 WHERE a.`status` = '0' AND a.`trademark_printing` = 'G/B GODDESS LOC 20\"' GROUP BY a.trademark_printing,a.colour_id HAVING COUNT(*) > 1";

        $lists = Db::query($sql);
        if($lists && is_array($lists)){

            foreach ($lists as $k => $v){
                //查出其他重复的物料方案
                $where['status'] = '0';
                $where['trademark_printing'] = $v['trademark_printing'];
                $where['colour_id'] = $v['colour_id'];
                $where['id'] = ['neq',$v['id']];
                $orthers = Db::name('material_plan')
                    ->where($where)
                    ->select();
                //如果存在就删除
               if($orthers){
                   foreach ($orthers as $key => $value){
                       $new_id = $v['id'];
                       $del_id = $value['id'];
                       //删除
                       if(!self::del_material_plan($del_id,$new_id)){
                           $flag = false;
                           break;
                       }
                   }
               }
                if ($flag == false) break;
            }
        }
        if($flag == true){
            Db::commit();
//            Db::rollback();
            $this->success('操作成功');
        }else{
            Db::rollback();
            $this->error('操作失败');
        }

    }

    function del_material_plan($del_id,$new_id){
        $materialPlanModel = new Materialplan();
        $acuisitionSchemeModel = new Acuisitionscheme();
        $deliverModel = new Deliver();
        //删除旧数据
       $materialPlanModel->where('id','eq',$del_id)->delete();

        //更新领料方案表
        $acuisitionSchemeModel->where('material_plan_id','eq',$del_id)->setField('material_plan_id',$new_id);

        //更新发料表
        $deliverModel->where('material_plan_id','eq',$del_id)->setField('material_plan_id',$new_id);
        return true;
    }

}
